---
title: FormatConditions.AddUniqueValues Method (Excel)
keywords: vbaxl10.chm510084
f1_keywords:
- vbaxl10.chm510084
ms.prod: excel
api_name:
- Excel.FormatConditions.AddUniqueValues
ms.assetid: 9cff98a9-7d7b-81ed-54b1-5919e681f904
ms.date: 06/08/2017
---


# FormatConditions.AddUniqueValues Method (Excel)

Returns a new  **[UniqueValues](uniquevalues-object-excel.md)** object representing a conditional formatting rule for the specified range.


## Syntax

 _expression_ . **AddUniqueValues**

 _expression_ A variable that represents a **FormatConditions** object.


### Return Value

 **UniqueValues** object


## Remarks

You can use the  **UniqueValues** object to quickly visualize cells that contain either unique or duplicate values.


## See also


#### Concepts


[FormatConditions Object](formatconditions-object-excel.md)

